Tabela InvoiceItem

Definicja tabeli InvoiceItem

Name

InvoiceItem

Code

InvoiceItem

Comment

PL: Opis pozycji faktury(w ramach zasad fakturowania)
EN: Corporate invoice item description


Lista kolumn tabeli InvoiceItem

Name

Code

InvoiceItemID

InvoiceItemID

InvoiceID

InvoiceID

BidCalculationPeriodID

BidCalculationPeriodID

CostCenterID

CostCenterID

PlaceID

PlaceID

PaymentTypeID

PaymentTypeID

CurrencyID

CurrencyID

DeviationActionID

DeviationActionID

PaymentTitleID

PaymentTitleID

PaymentPeriodID

PaymentPeriodID

ContractorID

ContractorID

PaymentFormID

PaymentFormID

BpPaymentTypeID

BpPaymentTypeID

Bid

Bid

InvoiceItemNo

InvoiceItemNo

InvoiceItemName

InvoiceItemName

InvoiceInAdvance

InvoiceInAdvance

YearIndexes

YearIndexes

FirstIndex

FirstIndex

SkipNearestIndex

SkipNearestIndex

BaseNumberOfPersons

BaseNumberOfPersons

BaseDeclinationPercent

BaseDeclinationPercent

StartDT

StartDT

StopDT

StopDT

Calculation

Calculation


Kolumna InvoiceItemID tabeli InvoiceItem

Definicja kolumny InvoiceItemID tabeli InvoiceItem

Name

InvoiceItemID

Code

InvoiceItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InvoiceID tabeli InvoiceItem

Definicja kolumny InvoiceID tabeli InvoiceItem

Name

InvoiceID

Code

InvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna BidCalculationPeriodID tabeli InvoiceItem

Definicja kolumny BidCalculationPeriodID tabeli InvoiceItem

Name

BidCalculationPeriodID

Code

BidCalculationPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostCenterID tabeli InvoiceItem

Definicja kolumny CostCenterID tabeli InvoiceItem

Name

CostCenterID

Code

CostCenterID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PlaceID tabeli InvoiceItem

Definicja kolumny PlaceID tabeli InvoiceItem

Name

PlaceID

Code

PlaceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTypeID tabeli InvoiceItem

Definicja kolumny PaymentTypeID tabeli InvoiceItem

Name

PaymentTypeID

Code

PaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CurrencyID tabeli InvoiceItem

Definicja kolumny CurrencyID tabeli InvoiceItem

Name

CurrencyID

Code

CurrencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DeviationActionID tabeli InvoiceItem

Definicja kolumny DeviationActionID tabeli InvoiceItem

Name

DeviationActionID

Code

DeviationActionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTitleID tabeli InvoiceItem

Definicja kolumny PaymentTitleID tabeli InvoiceItem

Name

PaymentTitleID

Code

PaymentTitleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentPeriodID tabeli InvoiceItem

Definicja kolumny PaymentPeriodID tabeli InvoiceItem

Name

PaymentPeriodID

Code

PaymentPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorID tabeli InvoiceItem

Definicja kolumny ContractorID tabeli InvoiceItem

Name

ContractorID

Code

ContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentFormID tabeli InvoiceItem

Definicja kolumny PaymentFormID tabeli InvoiceItem

Name

PaymentFormID

Code

PaymentFormID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BpPaymentTypeID tabeli InvoiceItem

Definicja kolumny BpPaymentTypeID tabeli InvoiceItem

Name

BpPaymentTypeID

Code

BpPaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Bid tabeli InvoiceItem

Definicja kolumny Bid tabeli InvoiceItem

Name

Bid

Code

Bid

Data Type

FLOAT(5)

Mandatory

No

Comment

 


Kolumna InvoiceItemNo tabeli InvoiceItem

Definicja kolumny InvoiceItemNo tabeli InvoiceItem

Name

InvoiceItemNo

Code

InvoiceItemNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InvoiceItemName tabeli InvoiceItem

Definicja kolumny InvoiceItemName tabeli InvoiceItem

Name

InvoiceItemName

Code

InvoiceItemName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InvoiceInAdvance tabeli InvoiceItem

Definicja kolumny InvoiceInAdvance tabeli InvoiceItem

Name

InvoiceInAdvance

Code

InvoiceInAdvance

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna YearIndexes tabeli InvoiceItem

Definicja kolumny YearIndexes tabeli InvoiceItem

Name

YearIndexes

Code

YearIndexes

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FirstIndex tabeli InvoiceItem

Definicja kolumny FirstIndex tabeli InvoiceItem

Name

FirstIndex

Code

FirstIndex

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SkipNearestIndex tabeli InvoiceItem

Definicja kolumny SkipNearestIndex tabeli InvoiceItem

Name

SkipNearestIndex

Code

SkipNearestIndex

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BaseNumberOfPersons tabeli InvoiceItem

Definicja kolumny BaseNumberOfPersons tabeli InvoiceItem

Name

BaseNumberOfPersons

Code

BaseNumberOfPersons

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BaseDeclinationPercent tabeli InvoiceItem

Definicja kolumny BaseDeclinationPercent tabeli InvoiceItem

Name

BaseDeclinationPercent

Code

BaseDeclinationPercent

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli InvoiceItem

Definicja kolumny StartDT tabeli InvoiceItem

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli InvoiceItem

Definicja kolumny StopDT tabeli InvoiceItem

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Calculation tabeli InvoiceItem

Definicja kolumny Calculation tabeli InvoiceItem

Name

Calculation

Code

Calculation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli InvoiceItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli InvoiceItem

Definicja klucza Identifier_1 tabeli InvoiceItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment